 /****** Object:  Stored Procedure BulkOrderTerritoriesGetList    Script Date: Wednesday, November 21, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spBulkOrderTerritoriesGetListByBulkOrder]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spBulkOrderTerritoriesGetListByBulkOrder]
GO

	
CREATE PROCEDURE spBulkOrderTerritoriesGetListByBulkOrder	
	@BulkOrderID int
	
AS

SELECT
	[BulkOrderTerritories].[BulkOrderID],
	[BulkOrderTerritories].[TerritoryID],
	[HomeDelivered15Price],
	[CurrencyID]
FROM
	[BulkOrderTerritories] 
WHERE BulkOrderID = @BulkOrderID



GO

	
